Implementing an Automated Normalization System for Functional Independent Normal Form in Relational Databases
نویسندگان
چکیده
A deductive system for automated database normalization is implemented by using a HiLog reasoning engine. The system allows for checking a relational schema up to Boyce-Codd normal form (BCNF) and functional independency normal form (FINF). Examples of system usage are presented and discussed.
منابع مشابه
Applying Spanning Tree Graph Theory for Automatic Database Normalization
In Knowledge and Data Engineering field, relational database is the best repository to store data in a real world. It has been using around the world more than eight decades. Normalization is the most important process for the analysis and design of relational databases. It aims at creating a set of relational tables with minimum data redundancy that preserve consistency and facilitate correct ...
متن کاملRDBNorma: - A semi-automated tool for relational database schema normalization up to third normal form
In this paper a tool called RDBNorma is proposed, that uses a novel approach to represent a relational database schema and its functional dependencies in computer memory using only one linked list and used for semi-automating the process of relational database schema normalization up to third normal form. This paper addresses all the issues of representing a relational schema along with its fun...
متن کاملThe Effects of Normalisation on the Ability of Business End-Users to Detect Data Anomalies: An Experimental Evaluation
With the proliferation of relational database programs for PCs and other platforms, many business end-users are creating, maintaining, and querying their own databases. More importantly, business end-users use the output of these queries as the basis for operational, tactical, and strategic decisions. Inaccurate data reduce the expected quality of these decisions. Implementing various input val...
متن کاملUpdating Relational Databases through XML Views
This paper presents an overview of a process for updating relational databases through XML views. The process is based on a query language called R2X and on a concept of normalization for XML views. The R2X language constructs XML views from relational databases, while normalization removes the ambiguity in an XML view, thus solving the update problem. In order to normalize an XML view, we bene...
متن کاملAn Approach for Normalizing Fuzzy Relational Databases Based on Join Dependency
Fuzziness in databases is used to denote uncertain or incomplete data. Relational Databases stress on the nature of the data to be certain. This certainty based data is used as the basis of the normalization approach designed for traditional relational databases. But real world data may not always be certain, thereby making it necessary to design an approach for normalization that deals with fu...
متن کامل